Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 11688 |
| Missing cells | 36661 |
| Missing cells (%) | 14.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.9 MiB |
| Average record size in memory | 439.5 B |
Variable types
| DateTime | 2 |
|---|---|
| Numeric | 14 |
| Categorical | 3 |
| Text | 1 |
| Unsupported | 2 |
city_name has constant value "local" | Constant |
Autoconsumo (kWh) is highly overall correlated with Horário Económico (kWh) | High correlation |
Horário Económico (kWh) is highly overall correlated with Autoconsumo (kWh) and 1 other fields | High correlation |
Normal (kWh) is highly overall correlated with Horário Económico (kWh) | High correlation |
clouds_all is highly overall correlated with weather_description | High correlation |
feels_like is highly overall correlated with temp and 2 other fields | High correlation |
rain_1h is highly overall correlated with weather_description | High correlation |
temp is highly overall correlated with feels_like and 2 other fields | High correlation |
temp_max is highly overall correlated with feels_like and 2 other fields | High correlation |
temp_min is highly overall correlated with feels_like and 2 other fields | High correlation |
weather_description is highly overall correlated with clouds_all and 1 other fields | High correlation |
Data has 672 (5.7%) missing values | Missing |
Hora has 672 (5.7%) missing values | Missing |
Normal (kWh) has 672 (5.7%) missing values | Missing |
Horário Económico (kWh) has 672 (5.7%) missing values | Missing |
Autoconsumo (kWh) has 672 (5.7%) missing values | Missing |
Injeção na rede (kWh) has 672 (5.7%) missing values | Missing |
sea_level has 11688 (100.0%) missing values | Missing |
grnd_level has 11688 (100.0%) missing values | Missing |
rain_1h has 9253 (79.2%) missing values | Missing |
dt is uniformly distributed | Uniform |
DataHora has unique values | Unique |
dt has unique values | Unique |
dt_iso has unique values | Unique |
sea_level is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
grnd_level is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Hora has 459 (3.9%) zeros | Zeros |
Normal (kWh) has 6018 (51.5%) zeros | Zeros |
Horário Económico (kWh) has 6813 (58.3%) zeros | Zeros |
Autoconsumo (kWh) has 5657 (48.4%) zeros | Zeros |
clouds_all has 1882 (16.1%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-04 23:44:20.900441 |
|---|---|
| Analysis finished | 2025-11-04 23:44:46.885921 |
| Duration | 25.99 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
DataHora
Date
Unique
| Distinct | 11688 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 91.4 KiB |
| Minimum | 2021-09-01 00:00:00 |
|---|---|
| Maximum | 2022-12-31 23:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Data
Date
Missing
| Distinct | 459 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 672 |
| Missing (%) | 5.7% |
| Memory size | 91.4 KiB |
| Minimum | 2021-09-29 00:00:00 |
|---|---|
| Maximum | 2022-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Hora
Real number (ℝ)
Missing Zeros
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 672 |
| Missing (%) | 5.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.5 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 459 |
| Zeros (%) | 3.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5.75 |
| median | 11.5 |
| Q3 | 17.25 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 11.5 |
Descriptive statistics
| Standard deviation | 6.9225008 |
|---|---|
| Coefficient of variation (CV) | 0.60195659 |
| Kurtosis | -1.2041758 |
| Mean | 11.5 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0 |
| Sum | 126684 |
| Variance | 47.921017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 459 | 3.9% |
| 1 | 459 | 3.9% |
| 2 | 459 | 3.9% |
| 3 | 459 | 3.9% |
| 4 | 459 | 3.9% |
| 5 | 459 | 3.9% |
| 6 | 459 | 3.9% |
| 7 | 459 | 3.9% |
| 8 | 459 | 3.9% |
| 9 | 459 | 3.9% |
| Other values (14) | 6426 | |
| (Missing) | 672 | 5.7% |
| Value | Count | Frequency (%) |
| 0 | 459 | |
| 1 | 459 | |
| 2 | 459 | |
| 3 | 459 | |
| 4 | 459 | |
| 5 | 459 | |
| 6 | 459 | |
| 7 | 459 | |
| 8 | 459 | |
| 9 | 459 |
| Value | Count | Frequency (%) |
| 23 | 459 | |
| 22 | 459 | |
| 21 | 459 | |
| 20 | 459 | |
| 19 | 459 | |
| 18 | 459 | |
| 17 | 459 | |
| 16 | 459 | |
| 15 | 459 | |
| 14 | 459 |
Normal (kWh)
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 1282 |
|---|---|
| Distinct (%) | 11.6% |
| Missing | 672 |
| Missing (%) | 5.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.20227805 |
| Minimum | 0 |
|---|---|
| Maximum | 3.251 |
| Zeros | 6018 |
| Zeros (%) | 51.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.314 |
| 95-th percentile | 0.896 |
| Maximum | 3.251 |
| Range | 3.251 |
| Interquartile range (IQR) | 0.314 |
Descriptive statistics
| Standard deviation | 0.34947829 |
|---|---|
| Coefficient of variation (CV) | 1.7277124 |
| Kurtosis | 8.4381405 |
| Mean | 0.20227805 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.5386084 |
| Sum | 2228.295 |
| Variance | 0.12213507 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6018 | |
| 0.001 | 23 | 0.2% |
| 0.008 | 19 | 0.2% |
| 0.018 | 17 | 0.1% |
| 0.016 | 17 | 0.1% |
| 0.252 | 17 | 0.1% |
| 0.253 | 17 | 0.1% |
| 0.006 | 16 | 0.1% |
| 0.003 | 16 | 0.1% |
| 0.026 | 15 | 0.1% |
| Other values (1272) | 4841 | |
| (Missing) | 672 | 5.7% |
| Value | Count | Frequency (%) |
| 0 | 6018 | |
| 0.001 | 23 | 0.2% |
| 0.002 | 14 | 0.1% |
| 0.003 | 16 | 0.1% |
| 0.004 | 14 | 0.1% |
| 0.005 | 11 | 0.1% |
| 0.006 | 16 | 0.1% |
| 0.007 | 14 | 0.1% |
| 0.008 | 19 | 0.2% |
| 0.009 | 11 | 0.1% |
| Value | Count | Frequency (%) |
| 3.251 | 1 | |
| 3.187 | 1 | |
| 2.862 | 1 | |
| 2.656 | 1 | |
| 2.585 | 1 | |
| 2.54 | 1 | |
| 2.519 | 1 | |
| 2.513 | 1 | |
| 2.491 | 1 | |
| 2.46 | 1 |
Horário Económico (kWh)
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 851 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 672 |
| Missing (%) | 5.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15971396 |
| Minimum | 0 |
|---|---|
| Maximum | 6.978 |
| Zeros | 6813 |
| Zeros (%) | 58.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.288 |
| 95-th percentile | 0.584 |
| Maximum | 6.978 |
| Range | 6.978 |
| Interquartile range (IQR) | 0.288 |
Descriptive statistics
| Standard deviation | 0.27179198 |
|---|---|
| Coefficient of variation (CV) | 1.7017421 |
| Kurtosis | 45.200384 |
| Mean | 0.15971396 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.8686343 |
| Sum | 1759.409 |
| Variance | 0.07387088 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6813 | |
| 0.263 | 34 | 0.3% |
| 0.256 | 31 | 0.3% |
| 0.321 | 29 | 0.2% |
| 0.26 | 27 | 0.2% |
| 0.259 | 26 | 0.2% |
| 0.262 | 26 | 0.2% |
| 0.251 | 25 | 0.2% |
| 0.27 | 24 | 0.2% |
| 0.281 | 23 | 0.2% |
| Other values (841) | 3958 | |
| (Missing) | 672 | 5.7% |
| Value | Count | Frequency (%) |
| 0 | 6813 | |
| 0.037 | 1 | < 0.1% |
| 0.038 | 1 | < 0.1% |
| 0.053 | 1 | < 0.1% |
| 0.062 | 1 | < 0.1% |
| 0.068 | 1 | < 0.1% |
| 0.069 | 1 | < 0.1% |
| 0.07 | 2 | < 0.1% |
| 0.075 | 1 | < 0.1% |
| 0.076 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6.978 | 1 | |
| 2.667 | 1 | |
| 2.613 | 1 | |
| 2.362 | 1 | |
| 2.182 | 1 | |
| 2.158 | 1 | |
| 2.151 | 1 | |
| 2.053 | 2 | |
| 1.937 | 1 | |
| 1.905 | 1 |
Autoconsumo (kWh)
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 752 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 672 |
| Missing (%) | 5.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.11731409 |
| Minimum | 0 |
|---|---|
| Maximum | 1.192 |
| Zeros | 5657 |
| Zeros (%) | 48.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.227 |
| 95-th percentile | 0.452 |
| Maximum | 1.192 |
| Range | 1.192 |
| Interquartile range (IQR) | 0.227 |
Descriptive statistics
| Standard deviation | 0.17676216 |
|---|---|
| Coefficient of variation (CV) | 1.5067429 |
| Kurtosis | 4.4481169 |
| Mean | 0.11731409 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.8879191 |
| Sum | 1292.332 |
| Variance | 0.031244863 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5657 | |
| 0.001 | 67 | 0.6% |
| 0.002 | 57 | 0.5% |
| 0.004 | 48 | 0.4% |
| 0.003 | 38 | 0.3% |
| 0.014 | 32 | 0.3% |
| 0.011 | 32 | 0.3% |
| 0.27 | 31 | 0.3% |
| 0.278 | 30 | 0.3% |
| 0.266 | 29 | 0.2% |
| Other values (742) | 4995 | |
| (Missing) | 672 | 5.7% |
| Value | Count | Frequency (%) |
| 0 | 5657 | |
| 0.001 | 67 | 0.6% |
| 0.002 | 57 | 0.5% |
| 0.003 | 38 | 0.3% |
| 0.004 | 48 | 0.4% |
| 0.005 | 23 | 0.2% |
| 0.006 | 29 | 0.2% |
| 0.007 | 21 | 0.2% |
| 0.008 | 27 | 0.2% |
| 0.009 | 23 | 0.2% |
| Value | Count | Frequency (%) |
| 1.192 | 1 | |
| 1.191 | 2 | |
| 1.189 | 1 | |
| 1.147 | 1 | |
| 1.141 | 1 | |
| 1.131 | 1 | |
| 1.127 | 1 | |
| 1.122 | 1 | |
| 1.119 | 1 | |
| 1.105 | 1 |
Injeção na rede (kWh)
Categorical
Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 672 |
| Missing (%) | 5.7% |
| Memory size | 611.7 KiB |
| None | |
|---|---|
| High | |
| Medium | |
| Very High | 606 |
| Low | 432 |
Length
| Max length | 9 |
|---|---|
| Median length | 4 |
| Mean length | 4.4351852 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | None |
|---|---|
| 2nd row | None |
| 3rd row | None |
| 4th row | None |
| 5th row | None |
Common Values
| Value | Count | Frequency (%) |
| None | 7777 | |
| High | 1103 | 9.4% |
| Medium | 1098 | 9.4% |
| Very High | 606 | 5.2% |
| Low | 432 | 3.7% |
| (Missing) | 672 | 5.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| none | 7777 | |
| high | 1709 | 14.7% |
| medium | 1098 | 9.4% |
| very | 606 | 5.2% |
| low | 432 | 3.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9481 | |
| o | 8209 | |
| N | 7777 | |
| n | 7777 | |
| i | 2807 | 5.7% |
| H | 1709 | 3.5% |
| g | 1709 | 3.5% |
| h | 1709 | 3.5% |
| M | 1098 | 2.2% |
| d | 1098 | 2.2% |
| Other values (8) | 5484 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 48858 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 9481 | |
| o | 8209 | |
| N | 7777 | |
| n | 7777 | |
| i | 2807 | 5.7% |
| H | 1709 | 3.5% |
| g | 1709 | 3.5% |
| h | 1709 | 3.5% |
| M | 1098 | 2.2% |
| d | 1098 | 2.2% |
| Other values (8) | 5484 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 48858 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 9481 | |
| o | 8209 | |
| N | 7777 | |
| n | 7777 | |
| i | 2807 | 5.7% |
| H | 1709 | 3.5% |
| g | 1709 | 3.5% |
| h | 1709 | 3.5% |
| M | 1098 | 2.2% |
| d | 1098 | 2.2% |
| Other values (8) | 5484 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 48858 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 9481 | |
| o | 8209 | |
| N | 7777 | |
| n | 7777 | |
| i | 2807 | 5.7% |
| H | 1709 | 3.5% |
| g | 1709 | 3.5% |
| h | 1709 | 3.5% |
| M | 1098 | 2.2% |
| d | 1098 | 2.2% |
| Other values (8) | 5484 |
dt
Real number (ℝ)
Uniform Unique
| Distinct | 11688 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.651491 × 109 |
| Minimum | 1.6304544 × 109 |
|---|---|
| Maximum | 1.6725276 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 1.6304544 × 109 |
|---|---|
| 5-th percentile | 1.6325581 × 109 |
| Q1 | 1.6409727 × 109 |
| median | 1.651491 × 109 |
| Q3 | 1.6620093 × 109 |
| 95-th percentile | 1.6704239 × 109 |
| Maximum | 1.6725276 × 109 |
| Range | 42073200 |
| Interquartile range (IQR) | 21036600 |
Descriptive statistics
| Standard deviation | 12147046 |
|---|---|
| Coefficient of variation (CV) | 0.0073551993 |
| Kurtosis | -1.2 |
| Mean | 1.651491 × 109 |
| Median Absolute Deviation (MAD) | 10519200 |
| Skewness | 0 |
| Sum | 1.9302627 × 1013 |
| Variance | 1.4755071 × 1014 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1672527600 | 1 | < 0.1% |
| 1630454400 | 1 | < 0.1% |
| 1630458000 | 1 | < 0.1% |
| 1630461600 | 1 | < 0.1% |
| 1630465200 | 1 | < 0.1% |
| 1630468800 | 1 | < 0.1% |
| 1630472400 | 1 | < 0.1% |
| 1630476000 | 1 | < 0.1% |
| 1672387200 | 1 | < 0.1% |
| 1672390800 | 1 | < 0.1% |
| Other values (11678) | 11678 |
| Value | Count | Frequency (%) |
| 1630454400 | 1 | |
| 1630458000 | 1 | |
| 1630461600 | 1 | |
| 1630465200 | 1 | |
| 1630468800 | 1 | |
| 1630472400 | 1 | |
| 1630476000 | 1 | |
| 1630479600 | 1 | |
| 1630483200 | 1 | |
| 1630486800 | 1 |
| Value | Count | Frequency (%) |
| 1672527600 | 1 | |
| 1672524000 | 1 | |
| 1672520400 | 1 | |
| 1672516800 | 1 | |
| 1672513200 | 1 | |
| 1672509600 | 1 | |
| 1672506000 | 1 | |
| 1672502400 | 1 | |
| 1672498800 | 1 | |
| 1672495200 | 1 |
dt_iso
Text
Unique
| Distinct | 11688 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 890.4 KiB |
Length
| Max length | 29 |
|---|---|
| Median length | 29 |
| Mean length | 29 |
| Min length | 29 |
Unique
| Unique | 11688 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 2021-09-01 00:00:00 +0000 UTC |
|---|---|
| 2nd row | 2021-09-01 01:00:00 +0000 UTC |
| 3rd row | 2021-09-01 02:00:00 +0000 UTC |
| 4th row | 2021-09-01 03:00:00 +0000 UTC |
| 5th row | 2021-09-01 04:00:00 +0000 UTC |
| Value | Count | Frequency (%) |
| 0000 | 11688 | |
| utc | 11688 | |
| 19:00:00 | 487 | 1.0% |
| 23:00:00 | 487 | 1.0% |
| 20:00:00 | 487 | 1.0% |
| 00:00:00 | 487 | 1.0% |
| 01:00:00 | 487 | 1.0% |
| 02:00:00 | 487 | 1.0% |
| 21:00:00 | 487 | 1.0% |
| 04:00:00 | 487 | 1.0% |
| Other values (503) | 19480 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 124867 | |
| 2 | 42673 | 12.6% |
| 35064 | 10.3% | |
| : | 23376 | 6.9% |
| - | 23376 | 6.9% |
| 1 | 21067 | 6.2% |
| + | 11688 | 3.4% |
| U | 11688 | 3.4% |
| T | 11688 | 3.4% |
| C | 11688 | 3.4% |
| Other values (7) | 21777 | 6.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 338952 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 124867 | |
| 2 | 42673 | 12.6% |
| 35064 | 10.3% | |
| : | 23376 | 6.9% |
| - | 23376 | 6.9% |
| 1 | 21067 | 6.2% |
| + | 11688 | 3.4% |
| U | 11688 | 3.4% |
| T | 11688 | 3.4% |
| C | 11688 | 3.4% |
| Other values (7) | 21777 | 6.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 338952 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 124867 | |
| 2 | 42673 | 12.6% |
| 35064 | 10.3% | |
| : | 23376 | 6.9% |
| - | 23376 | 6.9% |
| 1 | 21067 | 6.2% |
| + | 11688 | 3.4% |
| U | 11688 | 3.4% |
| T | 11688 | 3.4% |
| C | 11688 | 3.4% |
| Other values (7) | 21777 | 6.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 338952 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 124867 | |
| 2 | 42673 | 12.6% |
| 35064 | 10.3% | |
| : | 23376 | 6.9% |
| - | 23376 | 6.9% |
| 1 | 21067 | 6.2% |
| + | 11688 | 3.4% |
| U | 11688 | 3.4% |
| T | 11688 | 3.4% |
| C | 11688 | 3.4% |
| Other values (7) | 21777 | 6.4% |
city_name
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 616.5 KiB |
| local |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | local |
|---|---|
| 2nd row | local |
| 3rd row | local |
| 4th row | local |
| 5th row | local |
Common Values
| Value | Count | Frequency (%) |
| local | 11688 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| local | 11688 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 23376 | |
| o | 11688 | |
| c | 11688 | |
| a | 11688 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 58440 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 23376 | |
| o | 11688 | |
| c | 11688 | |
| a | 11688 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 58440 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 23376 | |
| o | 11688 | |
| c | 11688 | |
| a | 11688 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 58440 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 23376 | |
| o | 11688 | |
| c | 11688 | |
| a | 11688 |
temp
Real number (ℝ)
High correlation
| Distinct | 2423 |
|---|---|
| Distinct (%) | 20.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.406638 |
| Minimum | 0.32 |
|---|---|
| Maximum | 40.85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 0.32 |
|---|---|
| 5-th percentile | 8.2205 |
| Q1 | 12.35 |
| median | 15.76 |
| Q3 | 19.54 |
| 95-th percentile | 27.243 |
| Maximum | 40.85 |
| Range | 40.53 |
| Interquartile range (IQR) | 7.19 |
Descriptive statistics
| Standard deviation | 5.7159767 |
|---|---|
| Coefficient of variation (CV) | 0.34839416 |
| Kurtosis | 0.56477119 |
| Mean | 16.406638 |
| Median Absolute Deviation (MAD) | 3.62 |
| Skewness | 0.64852728 |
| Sum | 191760.78 |
| Variance | 32.672389 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14.59 | 62 | 0.5% |
| 15.7 | 55 | 0.5% |
| 16.82 | 51 | 0.4% |
| 12.92 | 46 | 0.4% |
| 16.81 | 45 | 0.4% |
| 17.92 | 41 | 0.4% |
| 15.17 | 39 | 0.3% |
| 11.26 | 39 | 0.3% |
| 12.37 | 37 | 0.3% |
| 15.15 | 37 | 0.3% |
| Other values (2413) | 11236 |
| Value | Count | Frequency (%) |
| 0.32 | 1 | |
| 0.99 | 1 | |
| 1.35 | 1 | |
| 1.8 | 1 | |
| 2.26 | 1 | |
| 2.59 | 1 | |
| 2.6 | 1 | |
| 2.73 | 1 | |
| 2.77 | 1 | |
| 2.95 | 1 |
| Value | Count | Frequency (%) |
| 40.85 | 1 | |
| 39.84 | 1 | |
| 39.69 | 1 | |
| 39.41 | 1 | |
| 39.26 | 1 | |
| 38.51 | 1 | |
| 38.47 | 1 | |
| 38.34 | 1 | |
| 38.21 | 1 | |
| 38.06 | 1 |
feels_like
Real number (ℝ)
High correlation
| Distinct | 2702 |
|---|---|
| Distinct (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.076164 |
| Minimum | -2.19 |
|---|---|
| Maximum | 41.33 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 4 |
| Negative (%) | < 0.1% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | -2.19 |
|---|---|
| 5-th percentile | 6.77 |
| Q1 | 11.76 |
| median | 15.675 |
| Q3 | 19.56 |
| 95-th percentile | 27.5765 |
| Maximum | 41.33 |
| Range | 43.52 |
| Interquartile range (IQR) | 7.8 |
Descriptive statistics
| Standard deviation | 6.2176046 |
|---|---|
| Coefficient of variation (CV) | 0.38675921 |
| Kurtosis | 0.58850497 |
| Mean | 16.076164 |
| Median Absolute Deviation (MAD) | 3.905 |
| Skewness | 0.55373506 |
| Sum | 187898.21 |
| Variance | 38.658607 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16.99 | 27 | 0.2% |
| 16.38 | 24 | 0.2% |
| 18.22 | 24 | 0.2% |
| 13.88 | 24 | 0.2% |
| 15.66 | 22 | 0.2% |
| 16.96 | 21 | 0.2% |
| 15.74 | 21 | 0.2% |
| 11.51 | 20 | 0.2% |
| 11.5 | 20 | 0.2% |
| 17.57 | 19 | 0.2% |
| Other values (2692) | 11466 |
| Value | Count | Frequency (%) |
| -2.19 | 1 | |
| -0.97 | 1 | |
| -0.6 | 1 | |
| -0.04 | 1 | |
| 0 | 1 | |
| 0.11 | 2 | |
| 0.22 | 1 | |
| 0.33 | 1 | |
| 0.49 | 1 | |
| 0.61 | 1 |
| Value | Count | Frequency (%) |
| 41.33 | 1 | |
| 40.46 | 1 | |
| 40.28 | 1 | |
| 39.87 | 1 | |
| 39.77 | 1 | |
| 39.55 | 2 | |
| 39.14 | 1 | |
| 39.1 | 1 | |
| 39.02 | 1 | |
| 38.98 | 1 |
temp_min
Real number (ℝ)
High correlation
| Distinct | 488 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.433353 |
| Minimum | -0.64 |
|---|---|
| Maximum | 36.72 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | -0.64 |
|---|---|
| 5-th percentile | 6.45 |
| Q1 | 10.9 |
| median | 14.54 |
| Q3 | 17.72 |
| 95-th percentile | 22.72 |
| Maximum | 36.72 |
| Range | 37.36 |
| Interquartile range (IQR) | 6.82 |
Descriptive statistics
| Standard deviation | 4.9605904 |
|---|---|
| Coefficient of variation (CV) | 0.3436894 |
| Kurtosis | 0.34749008 |
| Mean | 14.433353 |
| Median Absolute Deviation (MAD) | 3.18 |
| Skewness | 0.22796434 |
| Sum | 168697.03 |
| Variance | 24.607457 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17.72 | 471 | 4.0% |
| 16.72 | 400 | 3.4% |
| 15.72 | 335 | 2.9% |
| 18.72 | 309 | 2.6% |
| 19.72 | 296 | 2.5% |
| 14.72 | 243 | 2.1% |
| 12.72 | 239 | 2.0% |
| 13.72 | 225 | 1.9% |
| 20.72 | 223 | 1.9% |
| 21.72 | 185 | 1.6% |
| Other values (478) | 8762 |
| Value | Count | Frequency (%) |
| -0.64 | 1 | < 0.1% |
| -0.59 | 1 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| 0.16 | 1 | < 0.1% |
| 0.2 | 1 | < 0.1% |
| 0.46 | 1 | < 0.1% |
| 0.82 | 1 | < 0.1% |
| 1.06 | 1 | < 0.1% |
| 1.38 | 3 | |
| 1.72 | 4 |
| Value | Count | Frequency (%) |
| 36.72 | 1 | < 0.1% |
| 35.72 | 2 | |
| 35.57 | 1 | < 0.1% |
| 34.54 | 1 | < 0.1% |
| 33.73 | 1 | < 0.1% |
| 33.72 | 3 | |
| 33.43 | 1 | < 0.1% |
| 33.34 | 1 | < 0.1% |
| 33.03 | 1 | < 0.1% |
| 32.93 | 1 | < 0.1% |
temp_max
Real number (ℝ)
High correlation
| Distinct | 550 |
|---|---|
| Distinct (%) | 4.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.50299 |
| Minimum | 1.33 |
|---|---|
| Maximum | 41.45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 1.33 |
|---|---|
| 5-th percentile | 9.04 |
| Q1 | 12.93 |
| median | 16.72 |
| Q3 | 20.7 |
| 95-th percentile | 29.59 |
| Maximum | 41.45 |
| Range | 40.12 |
| Interquartile range (IQR) | 7.77 |
Descriptive statistics
| Standard deviation | 6.1123437 |
|---|---|
| Coefficient of variation (CV) | 0.34921711 |
| Kurtosis | 0.63762523 |
| Mean | 17.50299 |
| Median Absolute Deviation (MAD) | 3.83 |
| Skewness | 0.80056688 |
| Sum | 204574.95 |
| Variance | 37.360746 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.72 | 313 | 2.7% |
| 13.72 | 249 | 2.1% |
| 14.72 | 223 | 1.9% |
| 10.72 | 178 | 1.5% |
| 16.82 | 174 | 1.5% |
| 16.72 | 163 | 1.4% |
| 12.72 | 162 | 1.4% |
| 11.72 | 160 | 1.4% |
| 11.82 | 158 | 1.4% |
| 12.93 | 156 | 1.3% |
| Other values (540) | 9752 |
| Value | Count | Frequency (%) |
| 1.33 | 1 | |
| 2.88 | 1 | |
| 2.89 | 1 | |
| 3.34 | 1 | |
| 3.43 | 1 | |
| 3.8 | 1 | |
| 3.9 | 1 | |
| 3.99 | 1 | |
| 4 | 1 | |
| 4.04 | 1 |
| Value | Count | Frequency (%) |
| 41.45 | 2 | < 0.1% |
| 40.9 | 4 | |
| 40.34 | 3 | |
| 39.79 | 3 | |
| 39.59 | 1 | < 0.1% |
| 39.45 | 1 | < 0.1% |
| 39.23 | 4 | |
| 39.04 | 1 | < 0.1% |
| 38.68 | 5 | |
| 38.48 | 3 |
pressure
Real number (ℝ)
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1018.3041 |
| Minimum | 994 |
|---|---|
| Maximum | 1034 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 994 |
|---|---|
| 5-th percentile | 1009 |
| Q1 | 1015 |
| median | 1018 |
| Q3 | 1022 |
| 95-th percentile | 1029 |
| Maximum | 1034 |
| Range | 40 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 6.1097274 |
|---|---|
| Coefficient of variation (CV) | 0.0059999047 |
| Kurtosis | 0.71890967 |
| Mean | 1018.3041 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.31178371 |
| Sum | 11901938 |
| Variance | 37.328769 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1017 | 889 | 7.6% |
| 1018 | 881 | 7.5% |
| 1016 | 875 | 7.5% |
| 1019 | 775 | 6.6% |
| 1015 | 720 | 6.2% |
| 1020 | 708 | 6.1% |
| 1014 | 670 | 5.7% |
| 1021 | 611 | 5.2% |
| 1022 | 594 | 5.1% |
| 1023 | 563 | 4.8% |
| Other values (31) | 4402 |
| Value | Count | Frequency (%) |
| 994 | 3 | < 0.1% |
| 995 | 5 | < 0.1% |
| 996 | 9 | 0.1% |
| 997 | 32 | |
| 998 | 31 | |
| 999 | 15 | 0.1% |
| 1000 | 25 | |
| 1001 | 28 | |
| 1002 | 49 | |
| 1003 | 49 |
| Value | Count | Frequency (%) |
| 1034 | 1 | < 0.1% |
| 1033 | 26 | 0.2% |
| 1032 | 63 | 0.5% |
| 1031 | 136 | 1.2% |
| 1030 | 161 | |
| 1029 | 241 | |
| 1028 | 212 | |
| 1027 | 296 | |
| 1026 | 315 | |
| 1025 | 367 |
sea_level
Unsupported
Missing Rejected Unsupported
| Missing | 11688 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 91.4 KiB |
grnd_level
Unsupported
Missing Rejected Unsupported
| Missing | 11688 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 91.4 KiB |
humidity
Real number (ℝ)
| Distinct | 82 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 76.619011 |
| Minimum | 19 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 45 |
| Q1 | 66 |
| median | 81 |
| Q3 | 91 |
| 95-th percentile | 94 |
| Maximum | 100 |
| Range | 81 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 16.157421 |
|---|---|
| Coefficient of variation (CV) | 0.21088005 |
| Kurtosis | 0.066197588 |
| Mean | 76.619011 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.89178711 |
| Sum | 895523 |
| Variance | 261.06224 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 93 | 751 | 6.4% |
| 94 | 714 | 6.1% |
| 92 | 513 | 4.4% |
| 91 | 445 | 3.8% |
| 90 | 394 | 3.4% |
| 95 | 388 | 3.3% |
| 89 | 369 | 3.2% |
| 87 | 299 | 2.6% |
| 86 | 285 | 2.4% |
| 88 | 283 | 2.4% |
| Other values (72) | 7247 |
| Value | Count | Frequency (%) |
| 19 | 1 | < 0.1% |
| 20 | 4 | < 0.1% |
| 21 | 1 | < 0.1% |
| 22 | 10 | |
| 23 | 4 | < 0.1% |
| 24 | 6 | |
| 25 | 5 | < 0.1% |
| 26 | 9 | |
| 27 | 10 | |
| 28 | 13 |
| Value | Count | Frequency (%) |
| 100 | 2 | < 0.1% |
| 99 | 4 | < 0.1% |
| 98 | 12 | 0.1% |
| 97 | 16 | 0.1% |
| 96 | 108 | 0.9% |
| 95 | 388 | |
| 94 | 714 | |
| 93 | 751 | |
| 92 | 513 | |
| 91 | 445 |
wind_speed
Real number (ℝ)
| Distinct | 771 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.6476882 |
| Minimum | 0.06 |
|---|---|
| Maximum | 11.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 0.06 |
|---|---|
| 5-th percentile | 0.76 |
| Q1 | 1.61 |
| median | 2.38 |
| Q3 | 3.4 |
| 95-th percentile | 5.5165 |
| Maximum | 11.1 |
| Range | 11.04 |
| Interquartile range (IQR) | 1.79 |
Descriptive statistics
| Standard deviation | 1.458574 |
|---|---|
| Coefficient of variation (CV) | 0.55088585 |
| Kurtosis | 1.2846 |
| Mean | 2.6476882 |
| Median Absolute Deviation (MAD) | 0.87 |
| Skewness | 1.0334736 |
| Sum | 30946.18 |
| Variance | 2.127438 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.65 | 53 | 0.5% |
| 1.94 | 51 | 0.4% |
| 1.93 | 49 | 0.4% |
| 1.98 | 49 | 0.4% |
| 2.06 | 48 | 0.4% |
| 1.38 | 48 | 0.4% |
| 1.78 | 48 | 0.4% |
| 1.95 | 48 | 0.4% |
| 1.96 | 46 | 0.4% |
| 2.25 | 45 | 0.4% |
| Other values (761) | 11203 |
| Value | Count | Frequency (%) |
| 0.06 | 2 | < 0.1% |
| 0.08 | 1 | < 0.1% |
| 0.09 | 5 | |
| 0.1 | 1 | < 0.1% |
| 0.11 | 3 | |
| 0.13 | 2 | < 0.1% |
| 0.14 | 3 | |
| 0.15 | 2 | < 0.1% |
| 0.17 | 5 | |
| 0.18 | 3 |
| Value | Count | Frequency (%) |
| 11.1 | 1 | |
| 10.23 | 1 | |
| 10.03 | 1 | |
| 10.02 | 1 | |
| 9.33 | 1 | |
| 9.28 | 1 | |
| 9.27 | 1 | |
| 9.14 | 1 | |
| 9.1 | 1 | |
| 8.96 | 1 |
rain_1h
Real number (ℝ)
High correlation Missing
| Distinct | 371 |
|---|---|
| Distinct (%) | 15.2% |
| Missing | 9253 |
| Missing (%) | 79.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.88475975 |
| Minimum | 0.1 |
|---|---|
| Maximum | 7.45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 0.12 |
| Q1 | 0.21 |
| median | 0.45 |
| Q3 | 1.07 |
| 95-th percentile | 3.24 |
| Maximum | 7.45 |
| Range | 7.35 |
| Interquartile range (IQR) | 0.86 |
Descriptive statistics
| Standard deviation | 1.0734526 |
|---|---|
| Coefficient of variation (CV) | 1.2132701 |
| Kurtosis | 7.2020289 |
| Mean | 0.88475975 |
| Median Absolute Deviation (MAD) | 0.29 |
| Skewness | 2.4569753 |
| Sum | 2154.39 |
| Variance | 1.1523005 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.12 | 76 | 0.7% |
| 0.16 | 63 | 0.5% |
| 0.14 | 58 | 0.5% |
| 0.11 | 57 | 0.5% |
| 0.15 | 56 | 0.5% |
| 0.17 | 52 | 0.4% |
| 0.19 | 51 | 0.4% |
| 0.13 | 49 | 0.4% |
| 0.21 | 47 | 0.4% |
| 0.2 | 44 | 0.4% |
| Other values (361) | 1882 | 16.1% |
| (Missing) | 9253 |
| Value | Count | Frequency (%) |
| 0.1 | 36 | |
| 0.11 | 57 | |
| 0.12 | 76 | |
| 0.13 | 49 | |
| 0.14 | 58 | |
| 0.15 | 56 | |
| 0.16 | 63 | |
| 0.17 | 52 | |
| 0.18 | 42 | |
| 0.19 | 51 |
| Value | Count | Frequency (%) |
| 7.45 | 1 | |
| 7 | 1 | |
| 6.89 | 1 | |
| 6.75 | 1 | |
| 6.74 | 1 | |
| 6.72 | 1 | |
| 6.64 | 1 | |
| 6.61 | 1 | |
| 6.54 | 1 | |
| 6.53 | 1 |
clouds_all
Real number (ℝ)
High correlation Zeros
| Distinct | 101 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.258214 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 1882 |
| Zeros (%) | 16.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 91.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7 |
| median | 60 |
| Q3 | 98 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 91 |
Descriptive statistics
| Standard deviation | 40.443374 |
|---|---|
| Coefficient of variation (CV) | 0.74538713 |
| Kurtosis | -1.6368486 |
| Mean | 54.258214 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | -0.18571671 |
| Sum | 634170 |
| Variance | 1635.6665 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 2166 | 18.5% |
| 0 | 1882 | 16.1% |
| 99 | 439 | 3.8% |
| 1 | 333 | 2.8% |
| 98 | 319 | 2.7% |
| 2 | 226 | 1.9% |
| 97 | 224 | 1.9% |
| 96 | 201 | 1.7% |
| 95 | 168 | 1.4% |
| 3 | 147 | 1.3% |
| Other values (91) | 5583 |
| Value | Count | Frequency (%) |
| 0 | 1882 | |
| 1 | 333 | 2.8% |
| 2 | 226 | 1.9% |
| 3 | 147 | 1.3% |
| 4 | 124 | 1.1% |
| 5 | 91 | 0.8% |
| 6 | 81 | 0.7% |
| 7 | 76 | 0.7% |
| 8 | 75 | 0.6% |
| 9 | 73 | 0.6% |
| Value | Count | Frequency (%) |
| 100 | 2166 | |
| 99 | 439 | 3.8% |
| 98 | 319 | 2.7% |
| 97 | 224 | 1.9% |
| 96 | 201 | 1.7% |
| 95 | 168 | 1.4% |
| 94 | 113 | 1.0% |
| 93 | 142 | 1.2% |
| 92 | 98 | 0.8% |
| 91 | 101 | 0.9% |
weather_description
Categorical
High correlation
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 706.3 KiB |
| sky is clear | |
|---|---|
| overcast clouds | |
| light rain | |
| broken clouds | |
| scattered clouds | |
| Other values (3) |
Length
| Max length | 20 |
|---|---|
| Median length | 15 |
| Mean length | 12.869439 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | broken clouds |
|---|---|
| 2nd row | overcast clouds |
| 3rd row | overcast clouds |
| 4th row | light rain |
| 5th row | moderate rain |
Common Values
| Value | Count | Frequency (%) |
| sky is clear | 3160 | |
| overcast clouds | 2591 | |
| light rain | 1784 | |
| broken clouds | 1528 | |
| scattered clouds | 1213 | 10.4% |
| few clouds | 761 | 6.5% |
| moderate rain | 587 | 5.0% |
| heavy intensity rain | 64 | 0.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| clouds | 6093 | |
| sky | 3160 | |
| is | 3160 | |
| clear | 3160 | |
| overcast | 2591 | |
| rain | 2435 | 9.2% |
| light | 1784 | 6.7% |
| broken | 1528 | 5.7% |
| scattered | 1213 | 4.6% |
| few | 761 | 2.9% |
| Other values (3) | 715 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 16281 | |
| 14912 | ||
| c | 13057 | 8.7% |
| e | 11768 | 7.8% |
| r | 11514 | 7.7% |
| l | 11037 | 7.3% |
| o | 10799 | 7.2% |
| a | 10050 | 6.7% |
| d | 7893 | 5.2% |
| t | 7516 | 5.0% |
| Other values (12) | 35591 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 150418 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 16281 | |
| 14912 | ||
| c | 13057 | 8.7% |
| e | 11768 | 7.8% |
| r | 11514 | 7.7% |
| l | 11037 | 7.3% |
| o | 10799 | 7.2% |
| a | 10050 | 6.7% |
| d | 7893 | 5.2% |
| t | 7516 | 5.0% |
| Other values (12) | 35591 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 150418 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 16281 | |
| 14912 | ||
| c | 13057 | 8.7% |
| e | 11768 | 7.8% |
| r | 11514 | 7.7% |
| l | 11037 | 7.3% |
| o | 10799 | 7.2% |
| a | 10050 | 6.7% |
| d | 7893 | 5.2% |
| t | 7516 | 5.0% |
| Other values (12) | 35591 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 150418 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 16281 | |
| 14912 | ||
| c | 13057 | 8.7% |
| e | 11768 | 7.8% |
| r | 11514 | 7.7% |
| l | 11037 | 7.3% |
| o | 10799 | 7.2% |
| a | 10050 | 6.7% |
| d | 7893 | 5.2% |
| t | 7516 | 5.0% |
| Other values (12) | 35591 |
Interactions
Correlations
| Autoconsumo (kWh) | Hora | Horário Económico (kWh) | Injeção na rede (kWh) | Normal (kWh) | clouds_all | dt | feels_like | humidity | pressure | rain_1h | temp | temp_max | temp_min | weather_description | wind_speed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Autoconsumo (kWh) | 1.000 | 0.146 | -0.615 | 0.471 | 0.092 | -0.100 | -0.010 | 0.388 | -0.478 | -0.012 | -0.130 | 0.411 | 0.404 | 0.421 | 0.059 | 0.164 |
| Hora | 0.146 | 1.000 | -0.395 | 0.386 | 0.452 | -0.057 | 0.002 | 0.186 | -0.223 | -0.002 | -0.021 | 0.196 | 0.205 | 0.215 | 0.031 | 0.079 |
| Horário Económico (kWh) | -0.615 | -0.395 | 1.000 | 0.055 | -0.650 | 0.047 | 0.076 | -0.321 | 0.327 | 0.016 | -0.001 | -0.338 | -0.334 | -0.357 | 0.013 | -0.148 |
| Injeção na rede (kWh) | 0.471 | 0.386 | 0.055 | 1.000 | 0.137 | 0.117 | 0.130 | 0.250 | 0.287 | 0.067 | 0.060 | 0.258 | 0.265 | 0.254 | 0.114 | 0.087 |
| Normal (kWh) | 0.092 | 0.452 | -0.650 | 0.137 | 1.000 | 0.101 | -0.131 | -0.011 | 0.016 | 0.019 | 0.060 | -0.007 | -0.008 | 0.022 | 0.030 | 0.090 |
| clouds_all | -0.100 | -0.057 | 0.047 | 0.117 | 0.101 | 1.000 | 0.107 | -0.093 | 0.486 | -0.202 | 0.321 | -0.116 | -0.138 | -0.056 | 0.687 | 0.139 |
| dt | -0.010 | 0.002 | 0.076 | 0.130 | -0.131 | 0.107 | 1.000 | 0.183 | 0.138 | -0.285 | 0.140 | 0.169 | 0.182 | 0.156 | 0.155 | 0.068 |
| feels_like | 0.388 | 0.186 | -0.321 | 0.250 | -0.011 | -0.093 | 0.183 | 1.000 | -0.396 | -0.315 | 0.007 | 0.998 | 0.983 | 0.962 | 0.128 | -0.049 |
| humidity | -0.478 | -0.223 | 0.327 | 0.287 | 0.016 | 0.486 | 0.138 | -0.396 | 1.000 | -0.077 | 0.202 | -0.445 | -0.440 | -0.381 | 0.202 | -0.036 |
| pressure | -0.012 | -0.002 | 0.016 | 0.067 | 0.019 | -0.202 | -0.285 | -0.315 | -0.077 | 1.000 | -0.283 | -0.303 | -0.309 | -0.323 | 0.167 | -0.154 |
| rain_1h | -0.130 | -0.021 | -0.001 | 0.060 | 0.060 | 0.321 | 0.140 | 0.007 | 0.202 | -0.283 | 1.000 | -0.002 | -0.012 | 0.003 | 0.906 | 0.360 |
| temp | 0.411 | 0.196 | -0.338 | 0.258 | -0.007 | -0.116 | 0.169 | 0.998 | -0.445 | -0.303 | -0.002 | 1.000 | 0.985 | 0.963 | 0.125 | -0.041 |
| temp_max | 0.404 | 0.205 | -0.334 | 0.265 | -0.008 | -0.138 | 0.182 | 0.983 | -0.440 | -0.309 | -0.012 | 0.985 | 1.000 | 0.954 | 0.123 | -0.039 |
| temp_min | 0.421 | 0.215 | -0.357 | 0.254 | 0.022 | -0.056 | 0.156 | 0.962 | -0.381 | -0.323 | 0.003 | 0.963 | 0.954 | 1.000 | 0.103 | 0.017 |
| weather_description | 0.059 | 0.031 | 0.013 | 0.114 | 0.030 | 0.687 | 0.155 | 0.128 | 0.202 | 0.167 | 0.906 | 0.125 | 0.123 | 0.103 | 1.000 | 0.210 |
| wind_speed | 0.164 | 0.079 | -0.148 | 0.087 | 0.090 | 0.139 | 0.068 | -0.049 | -0.036 | -0.154 | 0.360 | -0.041 | -0.039 | 0.017 | 0.210 | 1.000 |
Missing values
Sample
| DataHora | Data | Hora | Normal (kWh) | Horário Económico (kWh) | Autoconsumo (kWh) | Injeção na rede (kWh) | dt | dt_iso | city_name | temp | feels_like | temp_min | temp_max | pressure | sea_level | grnd_level | humidity | wind_speed | rain_1h | clouds_all | weather_description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2021-09-01 00:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630454400 | 2021-09-01 00:00:00 +0000 UTC | local | 18.74 | 18.84 | 15.72 | 20.34 | 1015 | NaN | NaN | 83 | 1.18 | NaN | 78 | broken clouds |
| 1 | 2021-09-01 01:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630458000 | 2021-09-01 01:00:00 +0000 UTC | local | 18.73 | 18.83 | 15.72 | 20.34 | 1014 | NaN | NaN | 83 | 1.46 | NaN | 92 | overcast clouds |
| 2 | 2021-09-01 02:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630461600 | 2021-09-01 02:00:00 +0000 UTC | local | 17.84 | 17.98 | 16.72 | 20.34 | 1014 | NaN | NaN | 88 | 1.05 | NaN | 91 | overcast clouds |
| 3 | 2021-09-01 03:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630465200 | 2021-09-01 03:00:00 +0000 UTC | local | 18.27 | 18.40 | 16.68 | 20.34 | 1014 | NaN | NaN | 86 | 0.46 | 0.14 | 94 | light rain |
| 4 | 2021-09-01 04:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630468800 | 2021-09-01 04:00:00 +0000 UTC | local | 17.81 | 17.97 | 16.12 | 20.34 | 1013 | NaN | NaN | 89 | 0.93 | 1.26 | 95 | moderate rain |
| 5 | 2021-09-01 05:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630472400 | 2021-09-01 05:00:00 +0000 UTC | local | 17.89 | 18.06 | 16.12 | 17.93 | 1014 | NaN | NaN | 89 | 1.10 | 0.96 | 94 | light rain |
| 6 | 2021-09-01 06:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630476000 | 2021-09-01 06:00:00 +0000 UTC | local | 18.27 | 18.48 | 16.12 | 18.48 | 1014 | NaN | NaN | 89 | 1.21 | 0.11 | 93 | light rain |
| 7 | 2021-09-01 07:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630479600 | 2021-09-01 07:00:00 +0000 UTC | local | 19.44 | 19.69 | 16.68 | 19.59 | 1015 | NaN | NaN | 86 | 1.27 | 4.55 | 95 | heavy intensity rain |
| 8 | 2021-09-01 08:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630483200 | 2021-09-01 08:00:00 +0000 UTC | local | 18.92 | 19.19 | 16.68 | 19.04 | 1015 | NaN | NaN | 89 | 2.33 | 3.38 | 99 | moderate rain |
| 9 | 2021-09-01 09:00:00 | NaN | NaN | NaN | NaN | NaN | NaN | 1630486800 | 2021-09-01 09:00:00 +0000 UTC | local | 18.98 | 19.28 | 17.23 | 19.04 | 1015 | NaN | NaN | 90 | 2.23 | 0.52 | 100 | light rain |
| DataHora | Data | Hora | Normal (kWh) | Horário Económico (kWh) | Autoconsumo (kWh) | Injeção na rede (kWh) | dt | dt_iso | city_name | temp | feels_like | temp_min | temp_max | pressure | sea_level | grnd_level | humidity | wind_speed | rain_1h | clouds_all | weather_description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11678 | 2022-12-31 14:00:00 | 2022-12-31 | 14.0 | 1.060 | 0.000 | 0.166 | None | 1672495200 | 2022-12-31 14:00:00 +0000 UTC | local | 17.84 | 17.04 | 16.45 | 17.93 | 1017 | NaN | NaN | 52 | 6.73 | NaN | 41 | scattered clouds |
| 11679 | 2022-12-31 15:00:00 | 2022-12-31 | 15.0 | 1.340 | 0.000 | 0.039 | None | 1672498800 | 2022-12-31 15:00:00 +0000 UTC | local | 17.35 | 16.81 | 16.68 | 17.37 | 1017 | NaN | NaN | 64 | 8.35 | NaN | 77 | broken clouds |
| 11680 | 2022-12-31 16:00:00 | 2022-12-31 | 16.0 | 1.244 | 0.000 | 0.001 | None | 1672502400 | 2022-12-31 16:00:00 +0000 UTC | local | 16.79 | 16.38 | 15.90 | 16.82 | 1017 | NaN | NaN | 71 | 7.68 | 0.43 | 92 | light rain |
| 11681 | 2022-12-31 17:00:00 | 2022-12-31 | 17.0 | 2.101 | 0.000 | 0.000 | None | 1672506000 | 2022-12-31 17:00:00 +0000 UTC | local | 16.27 | 15.94 | 16.12 | 16.72 | 1017 | NaN | NaN | 76 | 7.31 | 1.47 | 95 | moderate rain |
| 11682 | 2022-12-31 18:00:00 | 2022-12-31 | 18.0 | 2.334 | 0.000 | 0.000 | None | 1672509600 | 2022-12-31 18:00:00 +0000 UTC | local | 15.76 | 15.53 | 14.79 | 16.72 | 1017 | NaN | NaN | 82 | 6.74 | 2.92 | 99 | moderate rain |
| 11683 | 2022-12-31 19:00:00 | 2022-12-31 | 19.0 | 1.693 | 0.000 | 0.000 | None | 1672513200 | 2022-12-31 19:00:00 +0000 UTC | local | 15.70 | 15.57 | 15.57 | 15.72 | 1018 | NaN | NaN | 86 | 5.56 | 3.58 | 100 | moderate rain |
| 11684 | 2022-12-31 20:00:00 | 2022-12-31 | 20.0 | 1.327 | 0.000 | 0.000 | None | 1672516800 | 2022-12-31 20:00:00 +0000 UTC | local | 15.55 | 15.43 | 12.72 | 15.70 | 1018 | NaN | NaN | 87 | 4.47 | 4.20 | 100 | heavy intensity rain |
| 11685 | 2022-12-31 21:00:00 | 2022-12-31 | 21.0 | 0.757 | 0.000 | 0.000 | None | 1672520400 | 2022-12-31 21:00:00 +0000 UTC | local | 13.45 | 13.28 | 12.23 | 13.99 | 1019 | NaN | NaN | 93 | 3.29 | 4.23 | 100 | heavy intensity rain |
| 11686 | 2022-12-31 22:00:00 | 2022-12-31 | 22.0 | 0.000 | 0.675 | 0.000 | None | 1672524000 | 2022-12-31 22:00:00 +0000 UTC | local | 12.93 | 12.73 | 12.23 | 13.43 | 1019 | NaN | NaN | 94 | 1.49 | 3.90 | 100 | moderate rain |
| 11687 | 2022-12-31 23:00:00 | 2022-12-31 | 23.0 | 0.000 | 0.403 | 0.000 | None | 1672527600 | 2022-12-31 23:00:00 +0000 UTC | local | 12.93 | 12.76 | 12.23 | 13.43 | 1019 | NaN | NaN | 95 | 1.93 | 4.07 | 100 | heavy intensity rain |